/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Version : 50722
 Source Host           : localhost
 Source Database       : empty_project

 Target Server Version : 50722
 File Encoding         : utf-8

 Date: 06/22/2018 01:03:54 AM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

DROP TABLE IF EXISTS `manager_user_record`;
CREATE TABLE IF NOT EXISTS `manager_user_record` (
  `record_id` BIGINT(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` BIGINT(11) NULL,
  `user_name` VARCHAR(45) NULL,
  `active_time` TIMESTAMP NOT NULL COMMENT '发生时间',
  `active_ip` VARCHAR(45) NULL COMMENT 'ip',
  `param_content` TEXT NULL COMMENT '参数值',
  `function_name` VARCHAR(45) NOT NULL COMMENT '操作的功能名称',
  PRIMARY KEY (`record_id`))
ENGINE = InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户操作日志';


-- ----------------------------
--  Table structure for `diy_function`
-- ----------------------------
DROP TABLE IF EXISTS `diy_function`;
CREATE TABLE `diy_function` (
  `function_id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(45) NOT NULL COMMENT '标题',
  `page_id` bigint(11) DEFAULT NULL COMMENT '页面ID',
  `type` tinyint(3) DEFAULT '1' COMMENT '1、弹窗，2、直接请求',
  `js_script` text,
  `redirect_to` varchar(255) DEFAULT NULL COMMENT '重定向页面',
  `permissions` varchar(300) DEFAULT NULL COMMENT '权限“,”分开',
  `location_type` tinyint(3) NOT NULL DEFAULT '1' COMMENT '1、页面方法，2、行方法',
  PRIMARY KEY (`function_id`),
  KEY `fk_diy_function_diy_page_idx` (`page_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='diy的功能';

-- ----------------------------
--  Records of `diy_function`
-- ----------------------------
BEGIN;
INSERT INTO `diy_function` VALUES ('1', '清空条件', '1', '2', 'window.location.href=\'/page.htm?id=1\';\n', null, '', '1'), ('2', '添加', '6', '2', '$.post(\"jsondata.json\",{\"id\":${SQL0},\"bank_name\":$(\'#bank_name\').val(),\'time_limit\':$(\'#time_limit\').val(),\'day_limit\':$(\'#time_limit\').val(),\'month_limit\':$(\'#time_limit\').val()},function(data){\nif (data.result == \"success\") {\n                        layui.layer.msg(\"添加成功\");\nwindow.location.reload();\n                    } else {\n                        layui.layer.msg(\"添加失败\");\n                    }\n})', null, '', '1'), ('3', '添加限额规则', '5', '1', null, 'page.htm?id=6', '', '1'), ('4', '修改银行限额', '7', '2', '$.post(\"jsondata.json\",{\"id\":${SQL0},\"limit_id\":$(\'#limit_id\').val(),\"bank_name\":$(\'#bank_name\').val(),\'time_limit\':$(\'#time_limit\').val(),\'day_limit\':$(\'#day_limit\').val(),\'month_limit\':$(\'#month_limit\').val()},function(data){\nif (data.result == \"success\") {\n                        layui.layer.msg(\"修改成功\");\nwindow.location.reload();\n                    } else {\n                        layui.layer.msg(\"修改失败\");\n                    }\n})', null, '', '1'), ('5', '修改限额', '5', '1', null, 'page.htm?id=7', '', '2'), ('6', '删除限额', '5', '2', '$.post(\"jsondata.json\",{\"id\":${SQL0},\"limit_id\":id},function(data){\nif (data.result == \"success\") {\n                        layui.layer.msg(\"删除成功\");\nwindow.location.reload();\n                    } else {\n                        layui.layer.msg(\"删除失败\");\n                    }\n})', null, '', '2'), ('7', '修改公告', '8', '2', '$.post(\"jsondata.json\",{\"id\":${SQL0},\"situation_id\":$(\'#situation_id\').val(),\"system_msg\":$(\'#system_msg\').val()},function(data){\nif (data.result == \"success\") {\nlayui.layer.msg(\"修改成功\");\n} else {\nlayui.layer.msg(\"修改失败\");\n}\n})', null, '', '1'), ('8', '标记为已服务', '14', '2', '$.post(\"jsondata.json\",{\"id\":${SQL0},\"user_id\":id},function(data){\nif (data.result == \"success\") {\nlayui.layer.msg(\"标记成功\");\nwindow.location.reload();\n} else {\nlayui.layer.msg(\"标记失败\");\n}\n})', null, null, '2');
COMMIT;

-- ----------------------------
--  Table structure for `diy_page`
-- ----------------------------
DROP TABLE IF EXISTS `diy_page`;
CREATE TABLE `diy_page` (
  `page_id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `title` varchar(45) NOT NULL COMMENT '标题',
  `im_menu` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否菜单，默认否',
  `type` tinyint(3) NOT NULL DEFAULT '1' COMMENT '0自定义页面，1标准页面，2外链',
  `html_content` text COMMENT '页面html',
  `field_map` varchar(400) DEFAULT NULL COMMENT '列对应',
  `permissions` varchar(300) DEFAULT NULL COMMENT '权限“,”分隔',
  `outer_url` varchar(255) DEFAULT NULL COMMENT '当type=2时，外链接',
  PRIMARY KEY (`page_id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='页面';

-- ----------------------------
--  Records of `diy_page`
-- ----------------------------
BEGIN;
INSERT INTO `diy_page` VALUES ('1', '交易列表', b'1', '1', null, 'order_id:订单ID,agent_name:代理,bus_name:商户,yp_code:易宝商编,mobile_name:商户电话,credit_no:信用卡号,credit_bank:信用卡银行,money:刷卡金额,fee:手续费,status:状态(1未支付，3成功),create_time:付款时间', '', ''), ('2', '代理池', b'1', '1', null, 'real_name:代理,agent_id:代理ID,allbus:拓展商户,bus_num:有效商户数,onum:有效单数,money:交易金额', 'data:agent', null), ('3', '每日数据统计', b'1', '1', null, 'days:日期,money:总成交,num:笔数,ymoney:积分成交,ynum:积分笔数,zmoney:积分C成交,znum:积分C笔数,bbmoney:积分B成交,bbnum:积分B笔数', 'data:trade', null), ('4', '用户分析', b'1', '1', null, 'todaynew:今日新增,fmagent:代理拓展,fmdefault:自然增加,weeknew:本周新增,todayuse:今日活跃', 'data:user', null), ('5', '银行限额', b'1', '1', null, 'limit_id:ID,passage_id:通道,bank_name:银行名称,time_limit:单次限额,day_limit:日限额,month_limit:月限额', 'data:banklimit', null), ('6', '添加银行限额', b'0', '0', '<form class=\"layui-form\" action=\"\" id=\"submitForm\">\n    <div class=\"layui-form-item\">\n        <label class=\"layui-form-label\">银行名</label>\n        <div class=\"layui-inline layui-input-inline\">\n            <input type=\"text\" id=\"bank_name\"  class=\"layui-input\">\n        </div>\n    </div>\n    <div class=\"layui-form-item\">\n        <label class=\"layui-form-label\">单次限额</label>\n        <div class=\"layui-inline layui-input-inline\">\n            <input type=\"text\" id=\"time_limit\"  class=\"layui-input\">\n        </div>\n    </div>\n    <div class=\"layui-form-item\">\n        <label class=\"layui-form-label\">单日限额</label>\n        <div class=\"layui-inline layui-input-inline\">\n            <input type=\"text\" id=\"day_limit\"  class=\"layui-input\">\n        </div>\n    </div>\n    <div class=\"layui-form-item\">\n        <label class=\"layui-form-label\">单月限额</label>\n        <div class=\"layui-inline layui-input-inline\">\n            <input type=\"text\" id=\"month_limit\"  class=\"layui-input\">\n        </div>\n    </div>\n    <div class=\"layui-form-item\">\n        <input type=\"button\" onclick=\"fun_2()\" value=\"添加\" class=\"btn\" />\n    </div>\n</form>', null, '', null), ('7', '修改银行限额', b'0', '0', '<form class=\"layui-form\" action=\"\" id=\"submitForm\">\n    <input type=\"hidden\" id=\"limit_id\" value=\"${rowid}\" />\n    <div class=\"layui-form-item\">\n        <label class=\"layui-form-label\">银行名</label>\n        <div class=\"layui-inline layui-input-inline\">\n            <input type=\"text\" id=\"bank_name\" value=\"${SQL0[0].bank_name}\" class=\"layui-input\">\n        </div>\n    </div>\n    <div class=\"layui-form-item\">\n        <label class=\"layui-form-label\">单次限额</label>\n        <div class=\"layui-inline layui-input-inline\">\n            <input type=\"text\" id=\"time_limit\" value=\"${SQL0[0].time_limit}\" class=\"layui-input\">\n        </div>\n    </div>\n    <div class=\"layui-form-item\">\n        <label class=\"layui-form-label\">单日限额</label>\n        <div class=\"layui-inline layui-input-inline\">\n            <input type=\"text\" id=\"day_limit\" value=\"${SQL0[0].day_limit}\" class=\"layui-input\">\n        </div>\n    </div>\n    <div class=\"layui-form-item\">\n        <label class=\"layui-form-label\">单月限额</label>\n        <div class=\"layui-inline layui-input-inline\">\n            <input type=\"text\" id=\"month_limit\" value=\"${SQL0[0].month_limit}\" class=\"layui-input\">\n        </div>\n    </div>\n    <div class=\"layui-form-item\">\n        <input type=\"button\" onclick=\"fun_4()\" value=\"确定修改\" class=\"btn\" />\n    </div>\n</form>', null, '', null), ('8', '修改公告', b'1', '0', '<form class=\"layui-form\" action=\"\" id=\"submitForm\">\n    <input type=\"hidden\" id=\"situation_id\" value=\"${SQL0[0].situation_id}\" />\n    <div class=\"layui-form-item\">\n        <label class=\"layui-form-label\">公告</label>\n        <div class=\"layui-inline layui-input-inline\">\n            <textarea style=\"width: 500px\" class=\"layui-textarea\" id=\"system_msg\">${SQL0[0].system_msg}</textarea>\n        </div>\n    </div>\n    <div class=\"layui-form-item\">\n        <button class=\"layui-btn layui-btn-small\" type=\"button\" onclick=\"fun_7()\">\n            <i class=\"layui-icon\">&#xe615;</i> 提交\n        </button>\n    </div>\n</form>', null, 'data:comment', ''), ('9', '商户管理', b'1', '1', null, 'user_id:ID,login_name:手机号,real_name:姓名,id_card:身份证,bank_name:银行,bank_number:储蓄卡,pname:通道,prate:费率', 'data:business', ''), ('10', '提升代理', b'1', '2', '', null, 'operat:upagent', '/wappage/agpage/upToAgent'), ('11', '会员查询', b'1', '2', '', null, 'member:list', '/members'), ('12', '交易查询', b'1', '2', '', null, 'trade:list', '/trades'), ('13', '通道管理', b'1', '2', '', null, 'system:passway', '/passways'), ('14', '不成交不推广', b'1', '1', null, 'user_id:ID,create_time:注册时间,ag_name:代理,ag_telephone:代理手机,real_name:姓名,login_name:手机号,bcount:交易失败次数,head_url:备注', 'data:notrade', '');
COMMIT;

-- ----------------------------
--  Table structure for `diy_search_param`
-- ----------------------------
DROP TABLE IF EXISTS `diy_search_param`;
CREATE TABLE `diy_search_param` (
  `param_id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '参数ID',
  `page_id` bigint(11) NOT NULL COMMENT '属于哪个页面',
  `field` varchar(45) NOT NULL COMMENT '字段',
  `type` tinyint(3) NOT NULL DEFAULT '1' COMMENT '1关键字，2下拉选择',
  `content` varchar(45) DEFAULT NULL COMMENT '值',
  `field_text` varchar(45) NOT NULL COMMENT '字段解释',
  PRIMARY KEY (`param_id`),
  KEY `fk_diy_search_param_diy_page1_idx` (`page_id`),
  CONSTRAINT `fk_diy_search_param_diy_page1` FOREIGN KEY (`page_id`) REFERENCES `diy_page` (`page_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='搜索条件';

-- ----------------------------
--  Records of `diy_search_param`
-- ----------------------------
BEGIN;
INSERT INTO `diy_search_param` VALUES ('8', '5', 'bank_name', '1', '', '银行'), ('9', '5', 'passage_id', '2', '全部:0,积分:1,普通:2,积分B:3', '通道'), ('10', '9', 'real_name', '1', '', '姓名'), ('11', '9', 'login_name', '1', '', '手机号'), ('12', '9', 'id_card', '1', '', '身份证'), ('13', '1', 'status', '2', '全部:0,未支付:1,成功:3', '状态'), ('14', '1', 'bus_name', '1', '', '商户名'), ('15', '1', 'credit_bank', '1', '', '刷卡行'), ('16', '14', 'ag_name', '1', null, '代理名称'), ('17', '14', 'tag_type', '2', '未标记:1,已标记:2', '状态');
COMMIT;

-- ----------------------------
--  Table structure for `diy_sql`
-- ----------------------------
DROP TABLE IF EXISTS `diy_sql`;
CREATE TABLE `diy_sql` (
  `sql_id` bigint(11) NOT NULL AUTO_INCREMENT,
  `sql_content` varchar(1000) DEFAULT NULL COMMENT 'sql语句',
  `use_for` tinyint(3) NOT NULL DEFAULT '1' COMMENT '1、页面初始化用，2、方法执行用',
  `target_id` bigint(11) NOT NULL COMMENT '目标ID，如果use_for是1，此处为page_id，如果是2此处为function_id',
  PRIMARY KEY (`sql_id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='sql语句';

-- ----------------------------
--  Records of `diy_sql`
-- ----------------------------
BEGIN;
INSERT INTO `diy_sql` VALUES ('6', 'select x.real_name,x.user_id as agent_id,x.acount as allbus,x.allmoney as money,x.enum as onum,x.dnum as bus_num from (\nselect t.user_id,t.real_name,f.acount,s.allmoney,s.enum,s.dnum from\n(SELECT a.* from manager_user a,manager_user_role b where a.user_id=b.user_id and b.role_id=4) t left join\n(SELECT c.agent_id,count(1) as acount from manager_user c group by c.agent_id) f on t.user_id=f.agent_id left join\n(SELECT u.agent_id,count(o.user_id) as enum,count(DISTINCT o.user_id) as dnum,sum(o.money) as allmoney from mo_order o,manager_user u where o.user_id=u.user_id and o.status=3 group by u.agent_id) s on t.user_id=s.agent_id\n) x order by x.allmoney desc', '1', '2'), ('7', 'select p.days,p.money,p.num,y.money as ymoney,y.num as ynum,z.money as zmoney,z.num as znum,bb.money as bbmoney,bb.num as bbnum from (select DATE_FORMAT(o.create_time,\'%Y%m%d\') as days,sum(o.money) as money,count(o.order_id) as num from mo_order o where o.`status`=3 GROUP BY days ORDER BY o.create_time desc) p\n left join (select DATE_FORMAT(o.create_time,\'%Y%m%d\') as days,sum(o.money) as money,count(o.order_id) as num from mo_order o where o.`status`=3 and o.passageway_id=1 GROUP BY days ORDER BY o.create_time desc) y on p.days=y.days\nleft join (select DATE_FORMAT(o.create_time,\'%Y%m%d\') as days,sum(o.money) as money,count(o.order_id) as num from mo_order o where o.`status`=3 and o.passageway_id=4 GROUP BY days ORDER BY o.create_time desc) z on y.days=z.days\nleft join (select DATE_FORMAT(o.create_time,\'%Y%m%d\') as days,sum(o.money) as money,count(o.order_id) as num from mo_order o where o.`status`=3 and o.passageway_id=3 GROUP BY days ORDER BY o.create_time desc) bb on y.days=bb.days', '1', '3'), ('9', 'select a.todaynew, b.fmagent, c.fmdefault, d.weeknew, e.todayuse from\n(\nselect COUNT(1) as todaynew from manager_user a1 where TO_DAYS(now())=TO_DAYS(a1.create_time) and a1.has_real_name=1\n) a,\n(\nselect COUNT(1) as fmagent from manager_user b1 where TO_DAYS( now() ) - TO_DAYS(b1.create_time) = 0 and b1.has_real_name=1 and b1.agent_id>1\n) b,\n(\nselect COUNT(1) as fmdefault from manager_user c1 where TO_DAYS( now() ) - TO_DAYS(c1.create_time) = 0 and c1.has_real_name=1 and c1.agent_id=1\n) c,\n(\nselect COUNT(1) as weeknew from manager_user d1 where YEARWEEK(date_format(d1.create_time,\'%Y-%m-%d\')) = YEARWEEK(now()) and d1.has_real_name=1\n) d,\n(\nselect COUNT(DISTINCT e1.user_id) as todayuse from mo_order e1 where TO_DAYS( now() ) - TO_DAYS(e1.create_time) = 0  and e1.`status`=3\n) e', '1', '4'), ('10', '', '2', '1'), ('14', 'select a.limit_id, b.title as passage_id, a.bank_name, a.time_limit, a.day_limit, a.month_limit\nfrom mo_bank_limit a,mo_passageway b\nwhere a.passage_id=b.passageway_id <#if bank_name??> and a.bank_name=\'${bank_name}\' </#if><#if passage_id??><#if passage_id!=\'0\'> and a.passage_id=\'${passage_id}\' </#if></#if>', '1', '5'), ('15', 'insert into mo_bank_limit(bank_name,time_limit,day_limit,month_limit) values(\'${bank_name}\',\'${time_limit}\',\'${day_limit}\',\'${month_limit}\')', '2', '2'), ('16', 'select * from mo_bank_limit where limit_id=${rowid}', '1', '7'), ('17', 'update mo_bank_limit set bank_name=\'${bank_name}\',time_limit=\'${time_limit}\',day_limit=\'${day_limit}\',month_limit=\'${month_limit}\' where limit_id=${limit_id}', '2', '4'), ('19', 'delete from mo_bank_limit where limit_id=${limit_id}', '2', '6'), ('21', 'select oem_id as situation_id,system_msg from `mo_oem` WHERE oem_flag=\'${_oemFlag}\'', '1', '8'), ('24', 'update `mo_oem` set system_msg=\'${system_msg}\' where oem_id=${situation_id}', '2', '7'), ('28', 'SELECT t.user_id,t.login_name,t.real_name,t.id_card,t.bank_name,t.bank_number,t.pname,t.prate from \n(SELECT a.user_id,a.login_name,a.real_name,a.id_card,a.bank_name,a.bank_number,group_concat(p.title SEPARATOR \',\' ) as pname,group_concat(c.rate SEPARATOR \',\' ) as prate\nfrom manager_user a,mo_passageway p,mo_passageway_account c\nWHERE a.user_id=c.user_id and p.passageway_id=c.passageway_id \n<#if real_name??> and a.real_name=\'${real_name}\' </#if>\n<#if login_name??> and a.login_name=\'${login_name}\' </#if>\n<#if id_card??> and a.id_card=\'${id_card}\'</#if>\nGROUP BY a.user_id) t', '1', '9'), ('31', 'select order_code as order_id, c.real_name as agent_name, concat(\'<a href=\"/page.htm?id=1&status=3&bus_name=\', b.real_name, \'\">\', b.real_name, \'</a>\') as bus_name, f.account_code as yp_code, a.mobile_name, a.credit_no, concat(\'<a href=\"/page.htm?id=1&status=3&credit_bank=\', a.credit_bank, \'\">\', a.credit_bank, \'</a>\') as credit_bank, a.money, a.fee, a.status, a.create_time from mo_order a, manager_user b, manager_user c, mo_passageway_account f where a.user_id=b.user_id and b.agent_id=c.user_id and b.user_id=f.user_id and a.passageway_id=f.passageway_id <#if status??><#if status!=\'0\'>and a.status=${status} </#if></#if> <#if bus_name??>and b.real_name=\'${bus_name}\' </#if> <#if credit_bank??>and a.credit_bank=\'${credit_bank}\'</#if> order by a.create_time desc', '1', '1'), ('32', 'select\n  a.user_id,\n  c.real_name as ag_name,\n  c.login_name as ag_telephone,\n  a.real_name,\n  a.login_name,\n  a.create_time,\n  b.bcount,\n  a.head_url\nfrom manager_user a INNER JOIN manager_user c ON a.agent_id=c.user_id LEFT JOIN (SELECT\n                                 x.user_id,\n                                 count(1) AS bcount\n                               FROM mo_order x\n                               GROUP BY x.user_id) b ON a.user_id = b.user_id\nwhere a.my_trade = 0 and a.child_number = 0 and a.has_real_name = 1 and a.oem_tag = \'${_oemFlag}\'\n                                                                        <#if ag_name??> and c.real_name=\'${ag_name}\' </#if>\n                                                                        <#if tag_type??>  <#if tag_type == \'1\' > and a.head_url is null <#else> and a.head_url is not null </#if> <#else>and a.head_url is null </#if>\norder by c.user_id,a.user_id desc', '1', '14'), ('33', 'update manager_user set head_url=\'已标记\' where user_id=\'${user_id}\'', '2', '8');
COMMIT;

-- ----------------------------
--  Table structure for `manager_permission`
-- ----------------------------
DROP TABLE IF EXISTS `manager_permission`;
CREATE TABLE `manager_permission` (
  `permission_id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `namespace` varchar(30) DEFAULT NULL,
  `permission_tag` varchar(60) DEFAULT NULL COMMENT '权限标签',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `create_user_id` bigint(11) DEFAULT NULL COMMENT '创建者Id',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '状态，1为可用0为不可用',
  `permission_comment` varchar(100) DEFAULT NULL COMMENT '权限备注',
  `parent_pid` bigint(11) DEFAULT NULL,
  PRIMARY KEY (`permission_id`)
) ENGINE=InnoDB AUTO_INCREMENT=266 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='权限表';

-- ----------------------------
--  Records of `manager_permission`
-- ----------------------------
BEGIN;
INSERT INTO `manager_permission` VALUES ('1', 'sup', 'sup:user', '2017-05-04 17:58:15', '1', '1', '超级管理', null), ('2', 'user', 'user:manager', '2017-05-04 17:55:37', '1', '1', '用户管理', '1'), ('3', 'user', 'user:list', '2017-05-04 17:56:46', '1', '1', '用户列表', '2'), ('4', 'user', 'user:add', '2017-05-04 17:59:21', '1', '1', '添加用户', '2'), ('5', 'user', 'user:modify', '2017-05-04 18:00:23', '1', '1', '修改用户', '2'), ('6', 'role', 'role:manager', '2017-05-04 19:35:46', '1', '1', '角色管理', '1'), ('7', 'role', 'role:add', '2017-05-05 11:03:22', '1', '1', '角色添加', '6'), ('8', 'role', 'role:list', '2017-05-05 11:04:00', '1', '1', '角色列表', '6'), ('9', 'role', 'role:modify', '2017-05-05 11:04:33', '1', '1', '角色权限', '6'), ('10', 'permission', 'permission:manager', '2017-05-05 11:07:00', '1', '1', '权限管理', '1'), ('11', 'permission', 'permission:list', '2017-05-05 11:07:03', '1', '1', '权限列表', '10'), ('12', 'permission', 'permission:top', '2017-05-05 11:07:06', '1', '1', '顶级权限', '10'), ('13', 'permission', 'permission:sub', '2017-05-05 11:07:08', '1', '1', '子级权限', '10'), ('193', 'sup', 'sup:diy', '2017-07-11 10:40:52', '1', '1', '功能创建管理员', null), ('194', 'diy', 'diy:manager', '2017-07-11 10:41:16', '1', '1', '功能创建', '193'), ('195', 'diy', 'diy:pages', '2017-07-11 10:41:34', '1', '1', '页面管理', '194'), ('196', 'diy', 'diy:funcs', '2017-07-11 10:41:47', '1', '1', '功能管理', '194'), ('197', 'diy', 'diy:addfunc', '2017-07-11 12:18:31', '1', '1', '添加功能', '196'), ('198', 'diy', 'diy:delfunc', '2017-07-11 15:59:10', '1', '1', '删除功能', '196'), ('199', 'diy', 'diy:newpage', '2017-07-12 12:34:30', '1', '1', '添加新页面', '195'), ('200', 'diy', 'diy:delpage', '2017-07-12 19:52:32', '1', '1', '删除页面', '195');
COMMIT;

-- ----------------------------
--  Table structure for `manager_role`
-- ----------------------------
DROP TABLE IF EXISTS `manager_role`;
CREATE TABLE `manager_role` (
  `role_id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_name` varchar(45) DEFAULT NULL COMMENT '角色名称',
  `role_tag` varchar(45) NOT NULL,
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `role_comment` varchar(255) DEFAULT NULL COMMENT '角色备注',
  `create_user_id` bigint(11) DEFAULT NULL COMMENT '登陆者用户ID',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '可用性，1为可用，0为不可用',
  PRIMARY KEY (`role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='角色表';

-- ----------------------------
--  Records of `manager_role`
-- ----------------------------
BEGIN;
INSERT INTO `manager_role` VALUES ('1', '超级管理员', 'sup', '2016-05-12 15:12:14', '最高权限', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `manager_role_permission`
-- ----------------------------
DROP TABLE IF EXISTS `manager_role_permission`;
CREATE TABLE `manager_role_permission` (
  `role_permission_id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_id` bigint(11) DEFAULT NULL COMMENT '角色Id',
  `permission_id` bigint(11) DEFAULT NULL COMMENT '权限Id',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `last_modify_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后刷新时间',
  PRIMARY KEY (`role_permission_id`)
) ENGINE=InnoDB AUTO_INCREMENT=777 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='角色、权限对应表';

-- ----------------------------
--  Records of `manager_role_permission`
-- ----------------------------
BEGIN;
INSERT INTO `manager_role_permission` VALUES ('1', '1', '1', '2017-05-04 18:03:56', '2017-05-04 18:05:27'), ('2', '1', '2', '2017-05-04 18:05:58', '2017-05-04 18:07:32'), ('3', '1', '3', '2017-05-04 18:06:21', '2017-05-04 18:07:54'), ('4', '1', '4', '2017-05-04 18:06:30', '2017-05-04 18:08:01'), ('5', '1', '5', '2017-05-04 18:06:45', '2017-05-04 18:08:15'), ('6', '1', '6', '2017-05-05 11:08:51', '2017-05-05 11:10:23'), ('7', '1', '7', '2017-05-05 11:08:13', '2017-05-05 11:09:45'), ('8', '1', '8', '2017-05-05 11:08:11', '2017-05-05 11:09:42'), ('9', '1', '9', '2017-05-05 11:08:08', '2017-05-05 11:09:39'), ('10', '1', '10', '2017-05-05 11:08:47', '2017-05-05 11:10:19'), ('11', '1', '11', '2017-05-05 11:08:45', '2017-05-05 11:10:17'), ('12', '1', '12', '2017-05-05 11:08:42', '2017-05-05 11:10:14'), ('13', '1', '13', '2017-05-05 11:08:39', '2017-05-05 11:10:11'), ('93', '1', '60', '2017-05-08 11:39:08', '2017-05-08 11:40:39'), ('94', '1', '61', '2017-05-08 11:39:09', '2017-05-08 11:40:40'), ('95', '1', '62', '2017-05-08 11:39:11', '2017-05-08 11:40:42'), ('96', '1', '63', '2017-05-08 11:39:11', '2017-05-08 11:40:42'), ('105', '1', '71', '2017-05-08 14:51:24', '2017-05-08 14:52:54'), ('117', '1', '75', '2017-05-08 15:00:17', '2017-05-08 15:01:48'), ('118', '1', '76', '2017-05-08 15:00:35', '2017-05-08 15:02:06'), ('119', '1', '77', '2017-05-08 15:00:58', '2017-05-08 15:02:29'), ('130', '1', '65', '2017-05-08 15:52:23', '2017-05-08 15:53:54'), ('136', '1', '79', '2017-05-08 15:56:15', '2017-05-08 15:57:45'), ('137', '1', '80', '2017-05-08 15:57:09', '2017-05-08 15:58:40'), ('138', '1', '81', '2017-05-08 16:09:35', '2017-05-08 16:11:06'), ('139', '1', '82', '2017-05-08 16:10:03', '2017-05-08 16:11:34'), ('140', '1', '83', '2017-05-08 16:10:28', '2017-05-08 16:11:59'), ('141', '1', '84', '2017-05-08 16:10:47', '2017-05-08 16:12:18'), ('142', '1', '85', '2017-05-08 16:11:05', '2017-05-08 16:12:36'), ('143', '1', '86', '2017-05-08 16:11:26', '2017-05-08 16:12:57'), ('144', '1', '87', '2017-05-08 16:11:47', '2017-05-08 16:13:18'), ('145', '1', '88', '2017-05-08 16:12:05', '2017-05-08 16:13:36'), ('146', '1', '89', '2017-05-08 16:44:15', '2017-05-08 16:45:45'), ('147', '1', '90', '2017-05-08 16:45:04', '2017-05-08 16:46:34'), ('148', '1', '91', '2017-05-08 16:45:25', '2017-05-08 16:46:56'), ('149', '1', '92', '2017-05-08 17:01:46', '2017-05-08 17:03:17'), ('150', '1', '93', '2017-05-08 17:02:05', '2017-05-08 17:03:36'), ('152', '1', '94', '2017-05-08 17:50:39', '2017-05-08 17:52:09'), ('154', '1', '67', '2017-05-08 18:20:10', '2017-05-08 18:21:41'), ('155', '1', '68', '2017-05-08 18:20:13', '2017-05-08 18:21:43'), ('156', '1', '69', '2017-05-08 18:20:13', '2017-05-08 18:21:44'), ('161', '1', '78', '2017-05-08 18:20:20', '2017-05-08 18:21:51'), ('162', '1', '95', '2017-05-08 19:01:36', '2017-05-08 19:03:07'), ('163', '1', '96', '2017-05-08 19:02:41', '2017-05-08 19:04:11'), ('164', '1', '97', '2017-05-08 19:04:22', '2017-05-08 19:05:52'), ('165', '1', '98', '2017-05-08 19:04:57', '2017-05-08 19:06:28'), ('166', '1', '99', '2017-05-08 19:05:19', '2017-05-08 19:06:49'), ('167', '1', '100', '2017-05-08 19:05:49', '2017-05-08 19:07:20'), ('168', '1', '101', '2017-05-08 19:06:06', '2017-05-08 19:07:36'), ('169', '1', '102', '2017-05-08 19:06:23', '2017-05-08 19:07:53'), ('178', '1', '103', '2017-05-09 10:03:52', '2017-05-09 10:03:52'), ('179', '1', '104', '2017-05-10 14:41:01', '2017-05-10 14:42:34'), ('180', '1', '105', '2017-05-10 16:45:26', '2017-05-10 16:46:59'), ('181', '1', '64', '2017-05-10 17:58:15', '2017-05-10 17:59:48'), ('182', '1', '70', '2017-05-10 17:58:16', '2017-05-10 17:59:48'), ('183', '1', '66', '2017-05-10 17:58:17', '2017-05-10 17:59:49'), ('184', '1', '72', '2017-05-10 17:58:18', '2017-05-10 17:59:51'), ('185', '1', '73', '2017-05-10 17:58:19', '2017-05-10 17:59:51'), ('186', '1', '74', '2017-05-10 17:58:19', '2017-05-10 17:59:52'), ('187', '1', '106', '2017-05-12 18:20:27', '2017-05-12 18:20:26'), ('188', '1', '107', '2017-05-13 14:22:23', '2017-05-13 14:23:57'), ('189', '1', '108', '2017-05-13 14:23:50', '2017-05-13 14:25:25'), ('190', '1', '109', '2017-05-13 14:25:12', '2017-05-13 14:26:47'), ('191', '1', '110', '2017-05-13 14:26:10', '2017-05-13 14:27:44'), ('192', '1', '111', '2017-05-13 14:27:49', '2017-05-13 14:29:24'), ('193', '1', '112', '2017-05-15 15:14:37', '2017-05-15 15:16:13'), ('261', '1', '113', '2017-05-15 15:50:14', '2017-05-15 15:50:14'), ('288', '1', '114', '2017-05-15 16:43:06', '2017-05-15 16:44:42'), ('289', '1', '115', '2017-05-15 16:43:49', '2017-05-15 16:45:26'), ('290', '1', '118', '2017-05-15 17:00:32', '2017-05-15 17:02:08'), ('291', '1', '119', '2017-05-15 17:00:33', '2017-05-15 17:02:09'), ('292', '1', '120', '2017-05-15 17:00:33', '2017-05-15 17:02:09'), ('293', '1', '121', '2017-05-15 17:00:34', '2017-05-15 17:02:10'), ('294', '1', '122', '2017-05-15 17:00:34', '2017-05-15 17:02:10'), ('295', '1', '123', '2017-05-15 17:00:34', '2017-05-15 17:02:11'), ('296', '1', '124', '2017-05-15 17:00:35', '2017-05-15 17:02:11'), ('297', '1', '125', '2017-05-15 17:00:36', '2017-05-15 17:02:12'), ('298', '1', '126', '2017-05-15 17:00:37', '2017-05-15 17:02:13'), ('299', '1', '127', '2017-05-15 17:00:37', '2017-05-15 17:02:13'), ('300', '1', '128', '2017-05-15 17:00:38', '2017-05-15 17:02:14'), ('301', '1', '129', '2017-05-15 17:00:38', '2017-05-15 17:02:14'), ('302', '1', '130', '2017-05-15 17:00:39', '2017-05-15 17:02:15'), ('303', '1', '131', '2017-05-15 17:00:39', '2017-05-15 17:02:15'), ('304', '1', '132', '2017-05-15 17:00:40', '2017-05-15 17:02:16'), ('305', '1', '133', '2017-05-15 17:00:40', '2017-05-15 17:02:16'), ('306', '1', '134', '2017-05-15 17:00:41', '2017-05-15 17:02:17'), ('307', '1', '135', '2017-05-15 17:00:41', '2017-05-15 17:02:17'), ('308', '1', '136', '2017-05-15 17:00:42', '2017-05-15 17:02:18'), ('309', '1', '141', '2017-05-15 17:00:42', '2017-05-15 17:02:18'), ('310', '1', '142', '2017-05-15 17:00:42', '2017-05-15 17:02:19'), ('311', '1', '143', '2017-05-15 17:00:43', '2017-05-15 17:02:19'), ('312', '1', '144', '2017-05-15 17:00:44', '2017-05-15 17:02:20'), ('313', '1', '145', '2017-05-15 17:00:44', '2017-05-15 17:02:20'), ('314', '1', '146', '2017-05-15 17:00:47', '2017-05-15 17:02:23'), ('315', '1', '147', '2017-05-15 17:00:47', '2017-05-15 17:02:23'), ('316', '1', '148', '2017-05-15 17:00:48', '2017-05-15 17:02:24'), ('317', '1', '149', '2017-05-15 17:00:48', '2017-05-15 17:02:24'), ('318', '1', '150', '2017-05-15 17:00:48', '2017-05-15 17:02:25'), ('319', '1', '151', '2017-05-15 17:00:49', '2017-05-15 17:02:25'), ('398', '1', '152', '2017-05-15 18:57:57', '2017-05-15 18:57:57'), ('399', '1', '153', '2017-05-15 19:01:50', '2017-05-15 19:01:49'), ('400', '1', '154', '2017-05-15 19:54:38', '2017-05-15 19:54:38'), ('409', '1', '155', '2017-05-17 18:56:29', '2017-05-17 18:58:07'), ('410', '1', '156', '2017-05-18 12:09:17', '2017-05-18 12:10:18'), ('426', '1', '157', '2017-05-19 15:00:38', '2017-05-19 15:00:38'), ('427', '1', '158', '2017-05-19 15:05:34', '2017-05-19 15:05:34'), ('428', '1', '159', '2017-05-19 15:06:21', '2017-05-19 15:06:20'), ('429', '1', '160', '2017-05-19 15:07:03', '2017-05-19 15:07:02'), ('430', '1', '161', '2017-05-19 15:07:49', '2017-05-19 15:07:48'), ('431', '1', '162', '2017-05-19 15:08:54', '2017-05-19 15:08:54'), ('432', '1', '163', '2017-05-19 15:09:38', '2017-05-19 15:09:37'), ('433', '1', '164', '2017-05-19 15:12:39', '2017-05-19 15:12:38'), ('434', '1', '165', '2017-05-19 15:12:59', '2017-05-19 15:12:59'), ('435', '1', '166', '2017-05-19 15:13:26', '2017-05-19 15:13:25'), ('436', '1', '167', '2017-05-19 15:14:09', '2017-05-19 15:14:09'), ('437', '1', '168', '2017-05-19 15:14:31', '2017-05-19 15:14:31'), ('438', '1', '169', '2017-05-19 15:16:10', '2017-05-19 15:16:10'), ('439', '1', '170', '2017-05-19 15:16:53', '2017-05-19 15:16:52'), ('440', '1', '171', '2017-05-19 15:53:44', '2017-05-19 15:53:43'), ('444', '1', '172', '2017-05-22 14:59:48', '2017-05-22 14:59:47'), ('445', '1', '173', '2017-05-22 15:01:14', '2017-05-22 15:01:14'), ('474', '1', '174', '2017-05-27 17:56:30', '2017-05-27 17:56:30'), ('475', '1', '175', '2017-05-27 17:56:53', '2017-05-27 17:56:53'), ('552', '1', '176', '2017-07-04 19:38:52', '2017-07-04 19:38:51'), ('553', '1', '177', '2017-07-05 10:12:41', '2017-07-05 10:12:53'), ('561', '1', '178', '2017-07-05 14:30:37', '2017-07-05 14:30:48'), ('562', '1', '179', '2017-07-05 15:25:06', '2017-07-05 15:25:17'), ('563', '1', '180', '2017-07-05 16:06:52', '2017-07-05 16:07:04'), ('564', '1', '181', '2017-07-05 16:12:27', '2017-07-05 16:12:38'), ('565', '1', '182', '2017-07-05 18:23:42', '2017-07-05 18:23:42'), ('566', '1', '183', '2017-07-05 18:52:51', '2017-07-05 18:52:50'), ('567', '1', '184', '2017-07-05 19:18:18', '2017-07-05 19:18:18'), ('568', '1', '185', '2017-07-06 11:17:14', '2017-07-06 11:17:14'), ('570', '1', '186', '2017-07-06 13:45:17', '2017-07-06 13:45:17'), ('571', '1', '187', '2017-07-06 16:09:23', '2017-07-06 16:09:22'), ('594', '1', '188', '2017-07-07 14:05:09', '2017-07-07 14:05:09'), ('596', '1', '189', '2017-07-07 14:12:35', '2017-07-07 14:12:34'), ('597', '1', '190', '2017-07-07 14:13:51', '2017-07-07 14:13:50'), ('598', '1', '191', '2017-07-07 14:14:26', '2017-07-07 14:14:25'), ('599', '1', '192', '2017-07-07 14:18:11', '2017-07-07 14:18:11'), ('600', '1', '193', '2017-07-11 10:40:52', '2017-07-11 10:40:51'), ('601', '1', '194', '2017-07-11 10:41:16', '2017-07-11 10:41:16'), ('602', '1', '195', '2017-07-11 10:41:34', '2017-07-11 10:41:33'), ('603', '1', '196', '2017-07-11 10:41:47', '2017-07-11 10:41:46'), ('604', '1', '197', '2017-07-11 12:18:31', '2017-07-11 12:18:38'), ('605', '1', '198', '2017-07-11 15:59:10', '2017-07-11 15:59:17'), ('606', '1', '199', '2017-07-12 12:34:30', '2017-07-12 12:34:37'), ('607', '1', '200', '2017-07-12 19:52:32', '2017-07-12 19:52:39'), ('608', '1', '201', '2017-07-12 20:48:29', '2017-07-12 20:48:30'), ('609', '1', '202', '2017-07-13 10:51:10', '2017-07-13 10:51:09'), ('614', '1', '203', '2017-07-31 16:51:26', '2017-07-31 16:51:26'), ('616', '1', '204', '2017-08-09 18:49:03', '2017-08-09 18:49:03'), ('618', '1', '205', '2017-08-12 12:08:07', '2017-08-12 12:09:39'), ('619', '1', '206', '2017-08-12 12:10:16', '2017-08-12 12:11:49'), ('620', '1', '207', '2017-08-12 12:13:02', '2017-08-12 12:14:35'), ('621', '1', '208', '2017-08-12 12:13:37', '2017-08-12 12:15:10'), ('622', '1', '209', '2017-08-12 12:14:03', '2017-08-12 12:15:35'), ('623', '1', '210', '2017-08-12 12:14:32', '2017-08-12 12:16:05'), ('629', '1', '211', '2017-08-12 17:38:16', '2017-08-12 17:38:16'), ('633', '1', '212', '2017-08-15 10:53:04', '2017-08-15 10:53:04'), ('634', '1', '213', '2017-08-15 10:53:31', '2017-08-15 10:53:31'), ('638', '1', '214', '2017-08-15 12:20:12', '2017-08-15 12:20:11'), ('642', '1', '215', '2017-08-25 13:39:05', '2017-08-25 13:39:04'), ('643', '1', '216', '2017-08-25 13:39:33', '2017-08-25 13:39:32'), ('644', '1', '217', '2017-08-25 13:39:57', '2017-08-25 13:39:57'), ('645', '1', '218', '2017-08-25 13:40:29', '2017-08-25 13:40:29'), ('654', '1', '219', '2017-08-29 09:45:44', '2017-08-29 09:45:44'), ('655', '1', '220', '2017-08-29 09:47:25', '2017-08-29 09:47:24'), ('656', '1', '221', '2017-08-29 09:48:21', '2017-08-29 09:48:21'), ('657', '1', '222', '2017-08-30 13:45:54', '2017-08-30 13:45:53'), ('662', '1', '223', '2017-09-19 10:39:34', '2017-09-19 10:39:34'), ('663', '1', '224', '2017-09-19 12:21:25', '2017-09-19 12:21:24'), ('664', '1', '225', '2017-09-19 12:21:55', '2017-09-19 12:21:54'), ('665', '1', '226', '2017-09-19 12:22:13', '2017-09-19 12:22:13'), ('673', '1', '227', '2017-10-13 17:55:43', '2017-10-13 17:55:42'), ('674', '1', '228', '2017-10-16 12:18:06', '2017-10-16 12:18:06'), ('675', '1', '229', '2017-10-16 12:18:59', '2017-10-16 12:18:58'), ('676', '1', '230', '2017-10-16 12:19:24', '2017-10-16 12:19:24'), ('680', '1', '231', '2017-10-16 12:25:47', '2017-10-16 12:25:46'), ('686', '1', '232', '2017-10-17 16:42:14', '2017-10-17 16:42:13'), ('687', '1', '233', '2017-10-17 16:42:39', '2017-10-17 16:42:38'), ('688', '1', '234', '2017-10-17 16:42:59', '2017-10-17 16:42:58'), ('689', '1', '235', '2017-10-17 16:43:21', '2017-10-17 16:43:21'), ('690', '1', '236', '2017-10-17 16:43:41', '2017-10-17 16:43:41'), ('696', '1', '237', '2017-10-18 09:56:00', '2017-10-18 09:55:59'), ('698', '1', '238', '2017-10-18 14:45:26', '2017-10-18 14:45:25'), ('699', '1', '239', '2017-10-18 14:45:46', '2017-10-18 14:45:46'), ('700', '1', '240', '2017-10-18 14:46:08', '2017-10-18 14:46:07'), ('701', '1', '241', '2017-10-19 15:34:27', '2017-10-19 15:34:27'), ('710', '1', '245', '2017-11-06 11:12:14', '2017-11-06 11:12:14'), ('711', '1', '246', '2017-12-07 14:27:04', '2017-12-07 14:23:58'), ('714', '1', '249', '2017-12-22 13:08:06', '2017-12-22 13:08:05'), ('715', '1', '250', '2017-12-22 13:08:23', '2017-12-22 13:08:22'), ('719', '1', '251', '2017-12-22 13:44:23', '2017-12-22 13:44:22'), ('721', '1', '252', '2017-12-22 20:35:30', '2017-12-22 20:35:29'), ('722', '1', '253', '2017-12-22 20:35:51', '2017-12-22 20:35:51'), ('725', '1', '254', '2017-12-22 21:08:37', '2017-12-22 21:08:37'), ('727', '1', '255', '2018-01-08 15:15:07', '2018-01-08 15:15:07'), ('729', '1', '256', '2018-02-03 13:46:45', '2018-02-03 13:46:45'), ('731', '1', '257', '2018-02-12 23:13:45', '2018-02-12 23:13:44'), ('735', '1', '259', '2018-03-15 11:19:41', '2018-03-15 11:19:40'), ('736', '1', '260', '2018-03-15 11:19:56', '2018-03-15 11:19:55'), ('740', '1', '262', '2018-03-15 12:16:26', '2018-03-15 12:16:25'), ('755', '1', '263', '2018-03-16 15:36:51', '2018-03-16 15:36:51'), ('757', '1', '264', '2018-03-16 17:04:50', '2018-03-16 17:04:49'), ('765', '1', '265', '2018-03-29 17:07:01', '2018-03-29 17:07:00');
COMMIT;

-- ----------------------------
--  Table structure for `manager_user`
-- ----------------------------
DROP TABLE IF EXISTS `manager_user`;
CREATE TABLE `manager_user` (
  `user_id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `nick` varchar(100) DEFAULT NULL COMMENT '用户昵称',
  `login_name` varchar(60) DEFAULT NULL COMMENT '用户登陆名',
  `password` varchar(64) DEFAULT NULL COMMENT '密码',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `status` tinyint(1) unsigned DEFAULT '1' COMMENT '用户状态，1为可用，0为不可用',
  `head_url` varchar(255) DEFAULT NULL COMMENT '用户头像',
  `last_login_ip` varchar(20) DEFAULT NULL COMMENT '最后登陆IP',
  `oem_flag` varchar(45) NOT NULL DEFAULT 'default' COMMENT 'oem标识',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';

-- ----------------------------
--  Records of `manager_user`
-- ----------------------------
BEGIN;
INSERT INTO `manager_user` VALUES ('1', '开发维护', 'kfwh', 'dcc62e31c8030d9488969c5da73d2f16', '2018-06-21 17:54:33', '1', null, null, 'default');
COMMIT;

-- ----------------------------
--  Table structure for `manager_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `manager_user_role`;
CREATE TABLE `manager_user_role` (
  `user_role_id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` bigint(11) DEFAULT NULL COMMENT '用户Id',
  `role_id` bigint(11) DEFAULT NULL COMMENT '解决Id',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`user_role_id`)
) ENGINE=InnoDB AUTO_INCREMENT=60900 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='用户角色表';

-- ----------------------------
--  Records of `manager_user_role`
-- ----------------------------
BEGIN;
INSERT INTO `manager_user_role` VALUES ('1', '1', '1', '2017-05-04 18:06:58');
COMMIT;

-- ----------------------------
--  Table structure for `system_oem`
-- ----------------------------
DROP TABLE IF EXISTS `system_oem`;
CREATE TABLE `system_oem` (
  `oem_id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `oem_flag` varchar(45) NOT NULL COMMENT 'oem标识',
  `domain` varchar(45) NOT NULL,
  `wx_app_id` varchar(45) NOT NULL COMMENT '微信appID',
  `wx_secret` varchar(64) NOT NULL COMMENT '微信密钥',
  `wx_qunfa` varchar(64) NOT NULL COMMENT '群发消息模板',
  `wx_tongzi` varchar(64) NOT NULL COMMENT '通知消息模板',
  PRIMARY KEY (`oem_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

SET FOREIGN_KEY_CHECKS = 1;
